CREATE TABLE IF NOT EXISTS customer_activities (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_email VARCHAR(255) NOT NULL,
    message_id VARCHAR(255) NOT NULL,
    conversation_id VARCHAR(255) DEFAULT NULL,
    from_email VARCHAR(255) DEFAULT NULL,
    from_name VARCHAR(255) DEFAULT NULL,
    to_recipients TEXT DEFAULT NULL,
    cc_recipients TEXT DEFAULT NULL,
    bcc_recipients TEXT DEFAULT NULL,
    subject VARCHAR(500) DEFAULT NULL,
    body_html LONGTEXT DEFAULT NULL,
    body_text LONGTEXT DEFAULT NULL,
    has_attachments TINYINT(1) DEFAULT 0,
    received_utc DATETIME DEFAULT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    UNIQUE KEY unique_message (user_email, message_id)
);



